WorkstationReportingPeriod

Entity Definition

Logical Name : WorkstationReportingPeriod
Physical Name : CA_PRD_RP_WS

A fiscal reporting period at a particular Workstation; has financial transactions attributed to it and is aggregated using the CalendarPeriod structure. May be opened and closed programmatically (eg: every day at 10:00pm precisely) or manually at each Workstation using POSPeriodStartTransaction and POSPeriodEndTransaction

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkstationID (FK)(PK) The unique identifier for the Workstation that is defining this ReportingPeriod. ID_WS Identity integer Workstation(AS_WS)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
StartTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SRT IdentityUUID char(32) WorkstationPeriodStartTransaction(TR_WS_PD_SRT)
EndTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_END IdentityUUID char(32) WorkstationPeriodEndTransaction(TR_WS_PRD_END)

Relationships

Parent Entity Verb Phrase Child Entity
WorkstationPeriodStartTransaction opens WorkstationReportingPeriod
WorkstationPeriodEndTransaction closes WorkstationReportingPeriod
ReportingPeriod defines WorkstationReportingPeriod
Workstation defines WorkstationReportingPeriod

Logical Views containing WorkstationReportingPeriod

Logical View
Logical 02430 - Control Transaction - Period Open Close View